How to: Prevent a user from moving to a control.
Solution:
In the Form Design view, use the 'Tab Stop' property box in the property sheet of the form to prevent a user from moving to a control.
1) If the Database window is not activated, activate the Database window.
2) Click the 'Forms' tab in the Database window.
Forms tab
3) Select the desired form from the list box. (The selected form is highlighted.)
4) Click 'Design'. (The selected form appears in Design view, and the floating Toolbox appears.)
5) Select the desired control to be excluded from the tab order. (Handles appear around the selected control.)
6) Select the 'View' menu and select 'Properties'. (The property sheet appears.)
7) Select the 'Other' tab.
8) Click on the 'Tab Stop' box. (A down arrow appears.)
9) Click down arrow. (A drop-down list appears.)
10) Select 'No' from the 'Tab Stop' list to remove it from the tab order of the form.
11) Select the 'File' menu and select 'Save' to save the form.